Create Drill through Page Part2 15

Create Table Slicer   

 

·       Select Slicer Visualization

·       Drag and Drop GroupName(groups) from ADF_Groups

Format

·       General   

-        X-Position 16

-        Y-Position 272

-        Width       576

-        Height      64

 

·       Off Slicer header

·       Items

     -  Font Color              #F1C40F

      - Background           #34495E

       -Text                         10

·       Title

-        Title Text   ---- Group Name (Grouped)

-               Font Color                       #F1C40F

-               Background Color           #34495E

-        Alignment             Center

-        Text                         10

-        Font Family      Segoe UI Bold  

·       Background                           #34495E



                            Create Matrix Table

 

·       Select Matrix Visual

·       Drag and drop -CreatedDt    from ADF_GroupQuestions

                          - GroupName(groups)    ADF_Group

                          - GroupName,              ADF_Group

                          - GroupQuestionText    ADF_GroupQuestions

                          - Url                 ADF_GroupQuestions

·       Values            No. of Not Responded Qns

 

Format

            General

-        X-Position 16

-        Y-Position 336

-        Width       576

-        Height      320

 

           Grid      

-        Outline color          #F1C40F

-        Text Size              11

                    Column headers

-        Font Color             Black

-        Font family            Segoe UI Bold

-        Text Size         12

-        Alignment      Center

                     Row

-        Font Color           Black

-        Outline     Right Only

-        URL Icon      ON

          Field Formatting

-        No. of Not Responded Qns

 

          Conditional Formatting

-        No. of Not Responded Qns

                    Title         Off

                     Background White

                     Shadow ON




Create Questions & Not Responded % (Last 12)  Visualization 

·       Select Line and Clustered Column Chart

·       For the Shared Axis For the Week Hierarchy, For the Week, DayofWeek

·       For Column values Field Drag and Drop Total Answer Needed Qns

·       For Line values Field Drag and Drop % of Not Responded Qns  

·       Go to The Filters click on For the Week

-        Select Top N

-        Show Items Top  12

-        Drag and drop on by value Weekend from the date table 

Formatting

·       General

-        X- position 608

-        Y- position 272

-        Width 656

-         Hight 384

·       Legend

-        Color Black

-        Font Family Segoe (Bold)

-        Text Size 10

·       X-Axis

-        Color-------------- Black

-        Text Size ----------9

-        Font family -------Segoe UI Bold

-        Title Color --------Black

-        Title Size---------- 12

·       Y-Axis

-        Color --------#F1C40F

-        Text ----------10

-        Line Style ------Dotted

-        Show Secondary ---On

-        Align Zeros --------On

-        Scaler type -------- Liner

-        Color --------------#34495E

-        Text ----------------16

·       Data Color

-        % of Not Responded Qns -----#34495E

-        Default Color ------#F1C40F

·       Data Lab             

-        Customize Series   ON

          Total Answer Needed Qns

-        Show On

-        Color--------#F1C40F

-        Show background Color----Black 

·       Shapes

-        Shade area      ON

-        Stroke width     3

-        Join type      Round

-        Line style Dashed

-        Show marker   ON

-        Marker shape   Square

-        Marker size 5

-        Marker Color White

-        Stepped    ON

·       Title

-        Title text    FX

                 

                                   -        Font Color       #F1c40F

-        Background Color ------#34495E

-        Alignment------------Center

-        Font Family ----------Segoe UI Bold

 

·       Background

-        Color White

·       Shadow    ON

-        Color Back

·       Tooltip    ON

                                                                      

How to setup drill through power bi desktop

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough